pp108 : Querying by Group by Clause

Querying by Group by Clause
This topic describes the procedure to build query using the Group by clause.

Before you begin this task:
The aggregate fields present in the Group by text box should be present in the Select text box also.


When you build a query, you can group the result of the query as a Group by clause to get the business data.

  1. Select the Group by clause text box.
  2. Double-click the required attribute from the Attributes column. The selected attribute is added to Group by clause text box.